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