UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgnjfOXMyu+11u+Twk+XP65iiKux820p+fl2+U6xmfs='
WHERE
key_id = '392b72a05b3750981ed1127e1288ce917740eb9eb7d7c00c3622ae70f3941aba'
AND (
token = 'zgnjfOXMyu+11u+Twk+XP65iiKux820p+fl2+U6xmfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)