UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sO6KIgGnzcmP8IMSCXi0OkXOYh/ezDFpXf5PgAQK9P8='
WHERE
key_id = '16e2dcbea0665a196f4a08990b3758a170759472c5e3efab0d148e720724b3ad'
AND (
token = 'sO6KIgGnzcmP8IMSCXi0OkXOYh/ezDFpXf5PgAQK9P8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)