UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HcSRmmEPW2e1dlNmARj3rHV+0lXFpnP/0ziAwjAzrKA='
WHERE
key_id = 'a998474785dbe535fa6a1e1a69a743358c4df38dab79724de1ee6327284e2a58'
AND (
token = 'HcSRmmEPW2e1dlNmARj3rHV+0lXFpnP/0ziAwjAzrKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)