UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8RGo6UiNJKtigLUvSz8m5xJjyOSkGRzvcrE573SXMVU='
WHERE
key_id = 'bddd39b8fb3512ec0a7df1a7e24d9b8da1536263e98478ae283dd90b1728b925'
AND (
token = '8RGo6UiNJKtigLUvSz8m5xJjyOSkGRzvcrE573SXMVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)