UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zUPU6lZsMJvtPobQawvb6TcMpoU0TCcNoxeN51uKEzo='
WHERE
key_id = 'ce740965030090e7e146f51719f11100fce5cd9c9af3093629176dc237b09dab'
AND (
token = 'zUPU6lZsMJvtPobQawvb6TcMpoU0TCcNoxeN51uKEzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)