UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WPxu347y/CnWIGz6aPa5ljGeV58zdMf++yyERbhfBKM='
WHERE
key_id = 'c9b1880c2c3c2385ee0f9d43d21e469f4af985eb3c13327341a65f39a527547e'
AND (
token = 'WPxu347y/CnWIGz6aPa5ljGeV58zdMf++yyERbhfBKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)