UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHqSDt365xtXlnEjuBcHGm7XKgktHLjvTmwpYGEwj9M='
WHERE
key_id = '1a8c65dc64023c57a568af9315e5e61fe00f35e44e5e4309b52d9ab46fd0bf71'
AND (
token = 'gHqSDt365xtXlnEjuBcHGm7XKgktHLjvTmwpYGEwj9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)