UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOhJi28VnY3qmPWePMWdyx1SjzC4LNlPG8AcPlR+aHc='
WHERE
key_id = '50668b2fb2c94c87b3a10e77868d65e7433d2c32a35034a69367148972e0777f'
AND (
token = 'cOhJi28VnY3qmPWePMWdyx1SjzC4LNlPG8AcPlR+aHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)