UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hUoz6EY3q2geeCdBQNOK5TzO+LxGKVVA3KLaAhYBMg='
WHERE
key_id = '8648145ffae17682f510d47b184322ae976a1ead961a0f1881fae3a39eb1927c'
AND (
token = '8hUoz6EY3q2geeCdBQNOK5TzO+LxGKVVA3KLaAhYBMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)