UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5Yy93lWKpIG8mkTtSI0WuHkCq96uy4xDtClOm0C/Ps='
WHERE
key_id = 'c5436be348742a229c4f2da7df3f8f6612a1c61902b67698b82af27d311d21f0'
AND (
token = 'X5Yy93lWKpIG8mkTtSI0WuHkCq96uy4xDtClOm0C/Ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)