UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yfeY6JVOQAY6I417bhBs2mVGj/s4uGcfvPiDsudkdhE='
WHERE
key_id = 'c58218842d85e43018dfbc751aec94668fa1cca256562924d1c5b20ae9a9ac5a'
AND (
token = 'yfeY6JVOQAY6I417bhBs2mVGj/s4uGcfvPiDsudkdhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)