UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hfJDHe+HONZNKT4ZaekLNnfEUyvT2llWF8+r8nkfXw='
WHERE
key_id = '0126e50ddf7fc6120d12923a73f89535ad2cf4d0c2447210660c554e44bee635'
AND (
token = '2hfJDHe+HONZNKT4ZaekLNnfEUyvT2llWF8+r8nkfXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)