UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vN8BKPdefN9VFkJUoGGzRYhVrXzDXZmwV095uXVSSzU='
WHERE
key_id = 'a7f71bb05ef9a5e7fcc76a53892cd72c02c00cd45dd013ec70058f47450dc44e'
AND (
token = 'vN8BKPdefN9VFkJUoGGzRYhVrXzDXZmwV095uXVSSzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)