UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3sbMUOGZRmgQZVc03rH6a+jjKtKr2yhhA64LNVO8xtY='
WHERE
key_id = 'd5166b3785b7eb2d12c27a2943fdc30a1e8721dc1c10d8618fc5b42870408e9d'
AND (
token = '3sbMUOGZRmgQZVc03rH6a+jjKtKr2yhhA64LNVO8xtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)