UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+wzfPJGHIN72KJdL42Liu8TzRxT+NJEBE3dj+hkD5KU='
WHERE
key_id = 'de0104fae0dac875118af1863203658ba37d4cabf3a96b5efd56df82986b473c'
AND (
token = '+wzfPJGHIN72KJdL42Liu8TzRxT+NJEBE3dj+hkD5KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)