UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E3tqfsj0php5tyGsnRyEOXcMv7yABNzintGU53eiAio='
WHERE
key_id = '78b8e8c01a55fb3f6bfce8f06f6e50c58cdee1fa56627d5b5fc493b3539fc257'
AND (
token = 'E3tqfsj0php5tyGsnRyEOXcMv7yABNzintGU53eiAio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)