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