UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DzgD6AMvbjq3yon7VfoAEDlTFin3UoJaAKPXlw8qJoo='
WHERE
key_id = '5fddbf4546cd50ed590b3ad208cf2f9eaa90772d037fda45e6c1d63416124743'
AND (
token = 'DzgD6AMvbjq3yon7VfoAEDlTFin3UoJaAKPXlw8qJoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)