UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GiX1i2yJmZYLN1YHL6AIYZUdw25obbU4WIMYAvwdpA='
WHERE
key_id = 'd67c7d237de0f884881b6a2566c75af7a2d7278cfcc6a44459bd0a94489ab9c9'
AND (
token = '1GiX1i2yJmZYLN1YHL6AIYZUdw25obbU4WIMYAvwdpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)