UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LcQSDgnSElg8hS+YgiJ04MfFMkkPSIaC/YOdcbd8/Gk='
WHERE
key_id = '9427d65fa9ed5bcb9694983be2a73a2362c90e492cac1c9c450e121ec9856d36'
AND (
token = 'LcQSDgnSElg8hS+YgiJ04MfFMkkPSIaC/YOdcbd8/Gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)