UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XNhULvvZcXBtGUM/02plHegt8MBp/qBxfai2Qj/qHM='
WHERE
key_id = 'bd834ec02df05984de8700fbf38529b7af9a65bf49cd89e48f85eabbeccdbd87'
AND (
token = '4XNhULvvZcXBtGUM/02plHegt8MBp/qBxfai2Qj/qHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)