UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K28M0qtUbYU1TJS/W8V6sXd3zCiaXNWUG39oz0DuNzU='
WHERE
key_id = '0ec87936b9e8091dccf1fb53acab6e65d983a42b738e98cb5535cbb34fc78881'
AND (
token = 'K28M0qtUbYU1TJS/W8V6sXd3zCiaXNWUG39oz0DuNzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)