UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KcKmN7OAL/QsQOzW+nDUHV1c/3DRG3TEy5/13RTmxqk='
WHERE
key_id = '783191f41fcc2eaa1a5b8378d9792464f6c1e3e52bb94b01fd657aee7802e1a7'
AND (
token = 'KcKmN7OAL/QsQOzW+nDUHV1c/3DRG3TEy5/13RTmxqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)