UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWikYSjG12rKM7NIUfY+PJQGlIVL9wBG6PuiJOzqMSI='
WHERE
key_id = 'c9c1b926148159d99feddcc472cc528824f40dec924a4150259091e1ab44333e'
AND (
token = 'zWikYSjG12rKM7NIUfY+PJQGlIVL9wBG6PuiJOzqMSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)