UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSvZaSYhRQxQ2RBm/34k7TmK61Q7NQL1Nq0Ol33uIFU='
WHERE
key_id = 'ea9f84149eea407cd2439649fa66f9c667134be04494527f4c3682e89a03ca78'
AND (
token = 'bSvZaSYhRQxQ2RBm/34k7TmK61Q7NQL1Nq0Ol33uIFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)