UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7L6ykJZo2IlWUUJmKS0UnoGYG5O+XjFcpvwCih9Jeg='
WHERE
key_id = '9fa8ebbbe0f262c0b3604b93ddc4607d5db22cfcabe75e65b28735c55c211920'
AND (
token = 'k7L6ykJZo2IlWUUJmKS0UnoGYG5O+XjFcpvwCih9Jeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)