UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kqKQZd7Y42ef19Nvuiz+F9pRPcJgC1tsA5urj6sMKEk='
WHERE
key_id = '7e3c8756b14787582affacb9f27eec54ac867bd7431f7d9c2b8c566648b47968'
AND (
token = 'kqKQZd7Y42ef19Nvuiz+F9pRPcJgC1tsA5urj6sMKEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)