UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/jDo2BmYiMXdF3i7XHphMCH/kk0Qz65/IRO6BCD9u7E='
WHERE
key_id = 'c65769ebe53d532cd8e9af2002b2952b67508cf9c856d509141d3ae0b49979c7'
AND (
token = '/jDo2BmYiMXdF3i7XHphMCH/kk0Qz65/IRO6BCD9u7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)