UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlJ6acNpuJ3cYnw2ZibPMiY3IUW8b4LVHJJOgr0g44w='
WHERE
key_id = '69d6031912732aa63cf1a7bea21ec6a390fd5f3c6ed62bb941f8e546619a43ca'
AND (
token = 'ZlJ6acNpuJ3cYnw2ZibPMiY3IUW8b4LVHJJOgr0g44w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)