UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PiV6L9otW2iqPhUmhwA8sQKcFv9BNAc38jFeMcdNVx0='
WHERE
key_id = '0f93d49764e7e4ab36f1709a671fc4f3962b709780106bb42b22211b3a507ad8'
AND (
token = 'PiV6L9otW2iqPhUmhwA8sQKcFv9BNAc38jFeMcdNVx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)