UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pnIf4EuxGyiYGbuGDplVpm7MvUwXBQRUjb2UJQat8g='
WHERE
key_id = 'f16847c4bffd0fdf2a1116ef088ec1b9135aedd61c662280710cf2324cc2c7b2'
AND (
token = '9pnIf4EuxGyiYGbuGDplVpm7MvUwXBQRUjb2UJQat8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)