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