UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gs6xS307z04GgK5xpsxP3TLgg8qAlLoRpwmM5tIsC4s='
WHERE
key_id = '4fef0c46f823969f722a6bd0031bf21d491243a5ea65818c46caeb8d4ae3c4ab'
AND (
token = 'gs6xS307z04GgK5xpsxP3TLgg8qAlLoRpwmM5tIsC4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)